package com.acquisition.task.constants;

/**
 * SQL语句的常数
 *
 * @author wuqiwei
 * @date 2020/10/15
 */
public class SQLConstants {

	/**
	 * 数据库位置
	 */
	public static final String DATABASE_PATH = "/sdcard/Android/data/com.dcs.cn/files/databases/DataCollectionSystem.db";

	/**
	 * log路径
	 */
	public static final String LOG_PATH = "/sdcard/Android/data/com.dcs.cn/cache/log/";

	/**
	 * 表的前缀名
	 */
	public static final String TABLE_ALIAS = "t";

	/**
	 * sql条件, 意为"and"
	 */
	public static final String AND = "AND";

	/**
	 * sql条件, 意为"or"
	 */
	public static final String OR = "OR";

	/**
	 * sql条件精确查询, 意为"="
	 */
	public static final String EQ = "EQ";

	/**
	 * sql条件精确查询, 意为"!="
	 */
	public static final String NE = "NE";

	/**
	 * sql条件精确查询, 意为">="
	 */
	public static final String GE = "GE";

	/**
	 * sql条件精确查询, 意为"<="
	 */
	public static final String LE = "LE";

	/**
	 * sql条件精确查询, 意为">"
	 */
	public static final String GREAT = "GREAT";

	/**
	 * sql条件精确查询, 意为"<"
	 */
	public static final String LITTLE = "LITTLE";

	/**
	 * sql条件模糊查询, 意为"like"
	 */
	public static final String LIKE = "LIKE";

	/**
	 * 分页的页
	 */
	public static final String PAGE = "PAGE";

	/**
	 * 分页的行
	 */
	public static final String ROWS = "ROWS";

	/**
	 * 排序
	 */
	public static final String ORDERBY = "order by";

	/**
	 * 返回num条数据
	 */
	public static final String LIMIT_NUM = "num";

	/**
	 * 返回第rows后的数据，不包括该rows，必须搭配LIMIT_NUM用
	 */
	public static final String LIMIT_ROWS = "rows";

	/**
	 * 查询所有数据
	 */
	public static final String ALL = "ALL";

}
